Release 10.1A: OpenEdge Development:
Progress 4GL Handbook


Closing a query

When you are done with a query, you should close it using this statement:

CLOSE QUERY query-name. 

An OPEN QUERY statement automatically closes a query if it was previously open. For this reason, it isn’t essential to execute a CLOSE QUERY statement just before reopening a query. However, you should explicitly close a query when you are done with it and you are not immediately reopening it. This frees the system resources used by the query. After you close the query you cannot reference it again (with a GET statement, for instance). However, if there are records still in the buffer or buffers used by the query, they are still available after the query is closed unless your application has specifically released them.


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095